Magnet link info for 'Udemy - Excel with Excel Pivot Tables!-7959d12d60c9c261bf4c70e44b5c3fa4373505e0',download 'Udemy - Excel with Excel Pivot Tables!'

Files list

00_-_None,01_-_INTRODUCTION.mp4 2.31MB

00_-_None,02_-_COURSE_TRACKER_WORKBOOK.txt 317.00Bytes

00_-_None,04_-_BONUS_-_TOP_20_EXCEL_SHORTCUTS.txt 468.00Bytes

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,06_-_WORKBOOKS.txt 134.00Bytes

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,07_-_ARRANGING_YOUR_DATA_SET_~_Tabular_Format.mp4 15.75MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,08_-_ARRANGING_YOUR_DATA_SET_~_No_Gaps.mp4 15.73MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,09_-_ARRANGING_YOUR_DATA_SET_~_Formatting.mp4 6.72MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,10_-_ARRANGING_YOUR_DATA_SET_~_Tables.mp4 15.78MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,11_-_ARRANGING_YOUR_DATA_SET_~_TIP_-_Clean_Your_Data_Set.mp4 9.90MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,12_-_CREATING_A_PIVOT_TABLE_~_Inserting_a_Pivot_Table.mp4 13.84MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,13_-_CREATING_A_PIVOT_TABLE_~_Field_List_-_Activate_move_resize_and_layout.mp4 6.56MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,14_-_CREATING_A_PIVOT_TABLE_~_Field_List_and_Areas.mp4 19.24MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,15_-_CREATING_A_PIVOT_TABLE_~_Drill_down_to_audit.mp4 11.11MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,16_-_CREATING_A_PIVOT_TABLE_~_Sort_Field_List_from_A_to_Z.mp4 2.93MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,17_-_CREATING_A_PIVOT_TABLE_~_TIP_-_Double_click_on_any_labels_to_show_more_Fields.mp4 3.49MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,18_-_CREATING_A_PIVOT_TABLE_~_TIP_-_Defer_Layout_Update.mp4 3.43MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,19_-_OPTIONS_DATA_~_Pivot_Cache_explained.mp4 4.38MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,20_-_OPTIONS_DATA_~_Refresh.mp4 5.07MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,21_-_OPTIONS_DATA_~_Refresh_All.mp4 9.84MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,22_-_OPTIONS_DATA_~_Refresh_External_Data.mp4 21.40MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,23_-_OPTIONS_DATA_~_Import_from_Access_database.mp4 11.57MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,24_-_OPTIONS_DATA_~_Change_Data_Source.mp4 19.10MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,25_-_OPTIONS_ACTIONS_~_Clear_Filters_and_Clear_Pivot.mp4 4.82MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,26_-_OPTIONS_ACTIONS_~_Select_and_format.mp4 19.10MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,27_-_OPTIONS_ACTIONS_~_Move_a_Pivot_Table.mp4 4.23MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,28_-_DESIGN_STYLES_~_Pivot_Table_Styles.mp4 22.50MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,29_-_DESIGN_STYLES_~_Customising_a_Pivot_Table_Style.mp4 23.18MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,30_-_DESIGN_STYLES_~_Use_a_customised_style_in_another_workbook.mp4 7.44MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,31_-_DESIGN_LAYOUT_~_Subtotals.mp4 4.19MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,32_-_DESIGN_LAYOUT_~_Grand_Totals.mp4 4.81MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,33_-_DESIGN_LAYOUT_~_Report_Layouts.mp4 13.90MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,34_-_DESIGN_LAYOUT_~_Blank_Rows.mp4 2.81MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,35_-_DESIGN_LAYOUT_~_TIP_-_Show_the_Classic_Pivot_Table_Layout.mp4 5.79MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,36_-_OPTIONS_SHOW_~_Expand_and_Collapse_buttons.mp4 23.94MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,37_-_OPTIONS_SHOW_~_Move_and_Remove_Fields_and_Items.mp4 11.67MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,38_-_OPTIONS_SHOW_~_Show_Hide_Field_List.mp4 1.68MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,39_-_OPTIONS_SHOW_~_Show_Hide_Field_Headers.mp4 1.74MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,40_-_CUSTOMISATION_~_Change_Count_of_to_Sum_of.mp4 5.48MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,41_-_CUSTOMISATION_~_Number_formatting.mp4 7.49MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,42_-_CUSTOMISATION_~_Field_name_formatting.mp4 9.57MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,43_-_CUSTOMISATION_~_TIP_-_Predetermined_number_formatting.mp4 5.59MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,44_-_CUSTOMISATION_~_TIP_-_Change_Sum_views_in_Label_areas.mp4 3.11MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,45_-_LAYOUT_and_FORMAT_~_Indent_rows_in_compact_layout.mp4 5.77MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,46_-_LAYOUT_and_FORMAT_~_Change_the_layout_of_a_report_filter.mp4 6.02MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,47_-_LAYOUT_and_FORMAT_~_Format_error_values.mp4 3.45MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,48_-_LAYOUT_and_FORMAT_~_Format_empty_cells.mp4 7.00MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,49_-_LAYOUT_and_FORMAT_~_Keep_column_widths_upon_refresh.mp4 4.66MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,50_-_LAYOUT_and_FORMAT_~_TIP_-_Automatic_Refresh_a_Pivot_Table.mp4 4.18MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,51_-_LAYOUT_and_FORMAT_~_TIP_-_Printing_a_pivot_table_on_two_pages.mp4 6.14MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE,52_-_LAYOUT_and_FORMAT_~_TIP_-Show_report_filter_on_multiple_pages.mp4 12.74MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY,54_-_Create_multiple_subtotals.mp4 8.29MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY,55_-_Count.mp4 15.08MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY,56_-_Average.mp4 16.86MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY,57_-_Maximum.mp4 10.62MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY,58_-_Minimum.mp4 7.68MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY,59_-_Product.mp4 12.25MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY,60_-_Count_Numbers.mp4 8.07MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY,61_-_Std_Dev.mp4 24.78MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY,62_-_Varp.mp4 18.30MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY,63_-_TIP_-_Show_various_Grand_Totals.mp4 12.76MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY,64_-_TIP_-_Shortcuts_to_Field_and_Value_Field_Settings.mp4 11.01MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY,65_-_TIP_-_See_all_pivot_Items.mp4 20.20MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY,66_-_TIP_-_Show_a_unique_count.mp4 14.09MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS,68_-_Percent_of_Grand_Total.mp4 12.48MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS,69_-_Percent_of_Column_Total.mp4 11.31MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS,70_-_Percent_of_Row_Total.mp4 11.13MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS,71_-_Percent_Of.mp4 18.49MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS,72_-_Percent_of_Parent_Row_Total_NEW_IN_EXCEL_2010_.mp4 21.86MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS,73_-_Percent_of_Parent_Column_Total_NEW_IN_EXCEL_2010_.mp4 11.88MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS,74_-_Percent_of_Parent_Total_NEW_IN_EXCEL_2010_.mp4 16.57MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS,75_-_Difference_From.mp4 24.20MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS,76_-_Percent_Difference_From.mp4 20.05MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS,77_-_Running_Total_in.mp4 10.53MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS,78_-_Percent_Running_Total_in_NEW_IN_EXCEL_2010_.mp4 11.61MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS,79_-_Rank_Smallest_to_Largest_NEW_IN_EXCEL_2010_.mp4 8.38MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS,80_-_Rank_Largest_to_Smallest_NEW_IN_EXCEL_2010_.mp4 9.91MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS,81_-_Index.mp4 15.34MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS,82_-_TIP_-_Shortcuts_to_Show_Values_As.mp4 4.84MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS,83_-_CASE_STUDY_~_ACCOUNTING_-_Percent_of_Revenue_Margins.mp4 10.65MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS,84_-_CASE_STUDY_~_FINANCIAL_-_Actual_v_Plan_Variance_Report.mp4 23.10MB

04_-_GROUPING,86_-_Group_by_Date.mp4 8.80MB

04_-_GROUPING,87_-_Group_by_Months.mp4 8.32MB

04_-_GROUPING,88_-_Group_by_Quarters_and_Years.mp4 7.22MB

04_-_GROUPING,89_-_Group_by_Sales_ranges.mp4 13.89MB

04_-_GROUPING,90_-_Group_by_Text_fields.mp4 6.71MB

04_-_GROUPING,91_-_Group_by_Time.mp4 6.74MB

04_-_GROUPING,92_-_TIP_-_Shortcuts_to_Grouping.mp4 5.75MB

04_-_GROUPING,93_-_TIP_-_Grouping_by_Half_Years.mp4 5.46MB

04_-_GROUPING,94_-_TIP_-_Group_by_a_Date_that_starts_on_a_Monday.mp4 7.73MB

04_-_GROUPING,95_-_TIP_-_Grouping_by_a_custom_date.mp4 10.49MB

04_-_GROUPING,96_-_TIP_-_Group_by_fiscal_years_and_quarters.mp4 20.95MB

04_-_GROUPING,97_-_TIP_-_Errors_when_grouping_by_dates.mp4 11.70MB

04_-_GROUPING,98_-_TIP_-_Group_two_pivot_tables_independently.mp4 20.71MB

04_-_GROUPING,99_-_TIP_-_Fixing_the_problem_of_counting_grouped_sales.mp4 2.70MB

04_-_GROUPING,100_-_TIP_-_Display_dates_that_have_no_data.mp4 6.36MB

04_-_GROUPING,101_-_CASE_STUDY_~_ACCOUNTING_-_Quarterly_Comparative_Report.mp4 37.65MB

04_-_GROUPING,102_-_CASE_STUDY_~_FINANCIAL_-_Min_and_Max_Bank_Balance.mp4 20.14MB

05_-_SORTING,104_-_Sorting_by_Largest_or_Smallest.mp4 7.14MB

05_-_SORTING,105_-_Sort_an_Item_Row_Left_to_Right_.mp4 6.27MB

05_-_SORTING,106_-_Sort_manually_drag_write_right_click_.mp4 7.35MB

05_-_SORTING,107_-_Sort_using_a_Custom_List.mp4 11.65MB

05_-_SORTING,108_-_Override_a_Custom_List_sort.mp4 4.97MB

05_-_SORTING,109_-_Sort_row_from_A-Z_and_sales_from_Z-A.mp4 5.84MB

05_-_SORTING,110_-_TIP_-_Sort_new_items_added_to_your_data_source.mp4 4.71MB

05_-_SORTING,111_-_TIP_-_Clear_a_sort.mp4 2.70MB

05_-_SORTING,112_-_TIP_-_Sort_Largest_to_Smallest_Grand_Totals.mp4 2.24MB

06_-_FILTERING,114_-_Filter_by_Dates.mp4 25.11MB

06_-_FILTERING,115_-_Filter_by_Labels_-_Text.mp4 9.73MB

06_-_FILTERING,116_-_Filter_by_Labels_-_Numerical_Text.mp4 11.11MB

06_-_FILTERING,117_-_Filter_by_Values.mp4 15.13MB

06_-_FILTERING,118_-_Filter_by_Values_-_Top_or_Bottom_10_Items.mp4 8.12MB

06_-_FILTERING,119_-_Filter_by_Values_-_Top_or_Bottom_Percent.mp4 7.65MB

06_-_FILTERING,120_-_Filter_by_Values_-_Top_or_Bottom_Sum.mp4 6.63MB

06_-_FILTERING,121_-_Filter_by_Report_Filter.mp4 14.18MB

06_-_FILTERING,122_-_TIP_-_Shortcuts_to_filters.mp4 7.10MB

06_-_FILTERING,123_-_TIP_-_Keep_or_hide_selected_items.mp4 3.77MB

06_-_FILTERING,124_-_TIP_-_Filter_by_Text_wildcards_and_.mp4 12.39MB

06_-_FILTERING,125_-_TIP_-_Filter_by_multiple_fields.mp4 4.37MB

06_-_FILTERING,126_-_TIP_-_Apply_multiple_filters.mp4 7.40MB

06_-_FILTERING,127_-_TIP_-_Filter_by_multiple_values.mp4 4.98MB

06_-_FILTERING,128_-_TIP_-_Include_new_items_in_manual_filter.mp4 8.08MB

06_-_FILTERING,129_-_TIP_-_Clear_filters_with_one_click.mp4 6.37MB

06_-_FILTERING,130_-_TIP_-_Add_a_filter_for_the_column_items.mp4 3.03MB

06_-_FILTERING,131_-_CASE_STUDY_~_ACCOUNTING_-_Top_5_Expenses_report.mp4 9.47MB

06_-_FILTERING,132_-_CASE_STUDY_~_FINANCIAL_-_Top_25Percent_of_Channel_Partners.mp4 9.96MB

07_-_SLICERS_NEW_IN_EXCEL_2010,134_-_Insert_a_Slicer.mp4 13.79MB

07_-_SLICERS_NEW_IN_EXCEL_2010,135_-_Slicer_Styles.mp4 10.05MB

07_-_SLICERS_NEW_IN_EXCEL_2010,136_-_Creating_a_custom_style.mp4 22.90MB

07_-_SLICERS_NEW_IN_EXCEL_2010,137_-_Copy_a_custom_style_into_a_new_workbook.mp4 6.89MB

07_-_SLICERS_NEW_IN_EXCEL_2010,138_-_Slicer_Settings.mp4 21.98MB

07_-_SLICERS_NEW_IN_EXCEL_2010,139_-_Slicer_Size_and_Properties.mp4 10.64MB

07_-_SLICERS_NEW_IN_EXCEL_2010,140_-_Slicer_Connections_for_multiple_pivot_tables.mp4 13.76MB

07_-_SLICERS_NEW_IN_EXCEL_2010,141_-_TIP_-_Different_ways_to_filter_a_Slicer.mp4 4.57MB

07_-_SLICERS_NEW_IN_EXCEL_2010,142_-_TIP_-_Use_one_slicer_for_two_pivot_tables.mp4 6.58MB

07_-_SLICERS_NEW_IN_EXCEL_2010,143_-_TIP_-_Lock_the_workbook_but_not_the_slicer.mp4 6.92MB

07_-_SLICERS_NEW_IN_EXCEL_2010,144_-_TIP_-_Interactive_employee_photos_with_Slicers_FUN_.mp4 31.08MB

07_-_SLICERS_NEW_IN_EXCEL_2010,145_-_CASE_STUDY_~_ACCOUNTING_-_Select_a_Monthly_PandL_report_with_a_Slicer.mp4 20.95MB

07_-_SLICERS_NEW_IN_EXCEL_2010,146_-_CASE_STUDY_~_FINANCIAL_-_Base_Best_and_Worst_case_Forecast.mp4 22.65MB

08_-_CALCULATED_FIELDS_and_ITEMS,148_-_Creating_a_Calculated_Field.mp4 17.09MB

08_-_CALCULATED_FIELDS_and_ITEMS,149_-_Use_an_existing_Calculated_Field_in_a_new_calculation.mp4 12.79MB

08_-_CALCULATED_FIELDS_and_ITEMS,150_-_Editing_a_Calculated_Field.mp4 12.77MB

08_-_CALCULATED_FIELDS_and_ITEMS,151_-_Excel_formulas_and_Calculated_Fields.mp4 13.99MB

08_-_CALCULATED_FIELDS_and_ITEMS,152_-_Creating_a_Calculated_Item.mp4 17.67MB

08_-_CALCULATED_FIELDS_and_ITEMS,153_-_Use_an_existing_Calculated_Item_in_a_new_calculation.mp4 8.57MB

08_-_CALCULATED_FIELDS_and_ITEMS,154_-_Editing_a_Calculated_Item.mp4 13.79MB

08_-_CALCULATED_FIELDS_and_ITEMS,155_-_Excel_formulas_and_Calculated_Items.mp4 9.76MB

08_-_CALCULATED_FIELDS_and_ITEMS,156_-_Calculated_Item_on_Column_Labels.mp4 11.20MB

08_-_CALCULATED_FIELDS_and_ITEMS,157_-_Shortcomings_of_Calculated_Items.mp4 8.34MB

08_-_CALCULATED_FIELDS_and_ITEMS,158_-_TIP_-_Solve_Order_for_Calculated_Items.mp4 21.37MB

08_-_CALCULATED_FIELDS_and_ITEMS,159_-_TIP_-_List_Calculated_Field_and_Item_formulas.mp4 4.88MB

08_-_CALCULATED_FIELDS_and_ITEMS,160_-_TIP_-_Remove_a_Calculated_Field_temporarily.mp4 3.94MB

08_-_CALCULATED_FIELDS_and_ITEMS,161_-_TIP_-_Order_of_operations.mp4 4.52MB

08_-_CALCULATED_FIELDS_and_ITEMS,162_-_CASE_STUDY_~_ACCOUNTING_-_Creating_a_PandL_Pivot_Table_Report.mp4 58.60MB

08_-_CALCULATED_FIELDS_and_ITEMS,163_-_CASE_STUDY_~_FINANCIAL_-_Actuals_v_Plan_with_Calculated_Fields.mp4 50.99MB

09_-_PIVOT_CHARTS,165_-_Insert_a_Pivot_Chart.mp4 12.12MB

09_-_PIVOT_CHARTS,166_-_Insert_a_Slicer_with_a_Pivot_Chart.mp4 7.42MB

09_-_PIVOT_CHARTS,167_-_Pivot_Chart_Designs.mp4 15.04MB

09_-_PIVOT_CHARTS,168_-_Pivot_Chart_Layouts.mp4 20.35MB

09_-_PIVOT_CHARTS,169_-_Pivot_Chart_Formats.mp4 20.07MB

09_-_PIVOT_CHARTS,170_-_Limitations_of_Pivot_Charts_and_workarounds.mp4 8.20MB

09_-_PIVOT_CHARTS,171_-_Saving_a_Pivot_Chart_template.mp4 6.41MB

09_-_PIVOT_CHARTS,172_-_TIP_-_Shortcuts_to_formatting_a_Pivot_Chart.mp4 5.65MB

09_-_PIVOT_CHARTS,173_-_TIP_-_Link_chart_title_to_a_pivot_cell.mp4 3.88MB

09_-_PIVOT_CHARTS,174_-_TIP_-_Copying_a_second_chart.mp4 3.56MB

09_-_PIVOT_CHARTS,175_-_TIP_-_Put_a_chart_on_a_separate_page_with_F11.mp4 2.53MB

09_-_PIVOT_CHARTS,176_-_TIP_-_Insert_Pivot_Chart_straight_from_the_data_source.mp4 4.58MB

09_-_PIVOT_CHARTS,177_-_TIP_-_Paste_Pivot_Chart_to_your_email_as_a_picture.mp4 3.52MB

09_-_PIVOT_CHARTS,178_-_TIP_-_Paste_Pivot_Chart_to_PowerPoint_and_make_live_updates.mp4 5.88MB

09_-_PIVOT_CHARTS,179_-_TIP_-_Printing_a_Pivot_Chart.mp4 5.89MB

09_-_PIVOT_CHARTS,180_-_TIP_-_Include_a_Sparkline_with_your_pivot_table.mp4 5.54MB

09_-_PIVOT_CHARTS,181_-_TIP_-_Charts_Do_s_and_Don_ts.mp4 10.14MB

09_-_PIVOT_CHARTS,182_-_TIP_-_Change_Chart_Type_with_Slicers_FUN_.mp4 28.79MB

09_-_PIVOT_CHARTS,183_-_TIP_-_Workaround_to_creating_an_interactive_Scatter_graph.mp4 10.73MB

09_-_PIVOT_CHARTS,184_-_CASE_STUDY_~_ACCOUNTING_-_PandL_Pivot_Table_report_with_Graphs.mp4 38.49MB

09_-_PIVOT_CHARTS,185_-_CASE_STUDY_~_FINANCIAL_-_Pivot_Table_Slicer_and_Chart_Dashboard.mp4 67.81MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES,187_-_Intro_to_Conditional_Formatting.mp4 13.75MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES,188_-_Highlight_Cell_Rules_based_on_values.mp4 6.45MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES,189_-_Highlight_Cell_Rules_based_on_text_labels.mp4 4.41MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES,190_-_Highlight_Cell_Rules_based_on_date_labels.mp4 5.74MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES,191_-_Top_and_Bottom_Rules.mp4 17.07MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES,192_-_Data_Bars_Color_Scales_and_Icon_Sets_NEW_IN_EXCEL_2010_.mp4 24.18MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES,193_-_TIP_-_Format_only_cells_that_contain_-_For_Bonuses.mp4 7.30MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES,194_-_TIP_-_Format_only_Top_or_Bottom_ranked_values_-_Top_3_sales_per_year.mp4 8.60MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES,195_-_TIP_-_Format_values_that_are_above_or_below_the_average_-_For_Promotions.mp4 5.91MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES,196_-_TIP_-_Use_a_formula_to_determine_which_cells_to_format.mp4 9.45MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES,197_-_Use_selected_cells_to_format_multiple_fields.mp4 8.73MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES,198_-_All_cells_showing_values_to_format_multiple_fields.mp4 7.58MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES,199_-_Control_Conditional_Formatting_with_Slicers.mp4 10.47MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES,200_-_Show_text_in_the_Pivot_Table_Values_area.mp4 22.30MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES,201_-_Cond_Format_blank_cells_or_cells.mp4 5.65MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES,202_-_CASE_STUDY_~_ACCOUNTING_-_Accounts_Receivable_Ageing_Report_Matrix.mp4 27.31MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES,203_-_CASE_STUDY_~_FINANCIAL_-_Conditionally_Format_your_sales_results.mp4 15.55MB

11_-_GETPIVOTDATA_Formula,205_-_Intro_to_GETPIVOTDATA.mp4 22.06MB

11_-_GETPIVOTDATA_Formula,206_-_Create_a_custom_report_with_GETPIVOTDATA.mp4 21.83MB

11_-_GETPIVOTDATA_Formula,207_-_Reference_Dates_with_GETPIVOTDATA.mp4 11.04MB

11_-_GETPIVOTDATA_Formula,208_-_Data_validation_with_GETPIVOTDATA.mp4 12.68MB

11_-_GETPIVOTDATA_Formula,209_-_Shortfalls_of_GETPIVOTDATA.mp4 6.03MB

11_-_GETPIVOTDATA_Formula,210_-_TIP_-_Grand_Totals_to_the_left_of_the_pivot_table.mp4 13.42MB

11_-_GETPIVOTDATA_Formula,211_-_CASE_STUDY_~_ACCOUNTING_-_Live_forecasting_with_GETPIVOTDATA.mp4 31.02MB

11_-_GETPIVOTDATA_Formula,212_-_CASE_STUDY_~_FINANCIAL_-_Channel_Analysis_with_GETPIVOTDATA.mp4 24.99MB

12_-_MACROS_and_PIVOT_TABLES,214_-_Adding_the_Developer_tab_and_disabling_macros.mp4 9.08MB

12_-_MACROS_and_PIVOT_TABLES,215_-_Record_a_simple_macro_to_Refresh_a_pivot_table.mp4 17.51MB

12_-_MACROS_and_PIVOT_TABLES,216_-_Date_filter_macro.mp4 15.07MB

12_-_MACROS_and_PIVOT_TABLES,217_-_Different_pivot_table_views_macro.mp4 19.08MB

12_-_MACROS_and_PIVOT_TABLES,218_-_Top_10_macro.mp4 11.40MB

12_-_MACROS_and_PIVOT_TABLES,219_-_Add_macro_to_quick_access_toolbar.mp4 7.14MB

13_-_DATA_MANAGEMENT,220_-_WORKBOOKS.txt 55.00Bytes

13_-_DATA_MANAGEMENT,221_-_Reducing_file_memory_by_copying_existing_pivot_table.mp4 8.75MB

13_-_DATA_MANAGEMENT,222_-_Reducing_file_memory_by_deleting_the_data_source.mp4 12.23MB

13_-_DATA_MANAGEMENT,223_-_Reducing_file_memory_by_saving_file_as_Excel_Binary_Workbook.mp4 6.27MB

13_-_DATA_MANAGEMENT,224_-_Reducing_file_memory_by_keeping_data_source_in_MS_Access.mp4 10.37MB

13_-_DATA_MANAGEMENT,225_-_Compatibility_Issues_with_Excel_2007_and_Excel_2010.mp4 4.27MB

13_-_DATA_MANAGEMENT,226_-_Sharing_a_Pivot_Table_via_OneDrive.mp4 8.57MB

14_-_BONUS_VIDEOS,227_-_WORKBOOKS.txt 135.00Bytes

14_-_BONUS_VIDEOS,228_-_Sales_Forecasting_with_Calculated_Fields.mp4 21.27MB

14_-_BONUS_VIDEOS,229_-_Consolidate_with_a_Pivot_Table.mp4 22.14MB

14_-_BONUS_VIDEOS,230_-_Frequency_distribution_with_a_Pivot_Table.mp4 10.02MB

14_-_BONUS_VIDEOS,231_-_Break_Even_Model.mp4 9.42MB

14_-_BONUS_VIDEOS,232_-_Several_Slicer_custom_styles_for_you_to_use.mp4 6.87MB

14_-_BONUS_VIDEOS,233_-_Interactive_Balance_Sheet_Pivot_Table.mp4 47.83MB

14_-_BONUS_VIDEOS,234_-_Monthly_Sales_Manager_Performance_Report.mp4 27.67MB

14_-_BONUS_VIDEOS,235_-_Reconciling_customer_payments.mp4 6.45MB

14_-_BONUS_VIDEOS,236_-_THANK_YOU_.mp4 1.63MB